Create New Project in SSIS 10
Step 2: In Visual Studio, select File à New à Project to create a new Integration Services project.
Step 3: In the New Project dialog box, expand the Business Intelligence node under Installed, and select Integration Services Project in the pane on the right side. In the Name box, change the default name to SchoolGunViolenceDatamart. Accept the default location and select OK.
Step 4: By default, an empty package titled Package.dtsx is created and added to your project under SSIS Packages. In Solution Explorer, right-click Package.dtsx, select Rename, and rename the default package to LoadJsonFile.
SQL Server Integration Service (SSIS) is a component of the Microsoft SQL Server database software that can be used to execute a wide range of data migration tasks. SSIS is a fast & flexible data warehousing tool used for data extraction, loading and transformation like cleaning, aggregating, merging data, etc.